import openpyxl
import re
workbook = openpyxl.load_workbook('tmp.xlsx')

sheet = workbook["Sheet1"]
# 获取最大列数
maxColumn = sheet.max_column
print('最大列',maxColumn)
max_row=sheet.max_row
print('最大行',max_row)


for one_column_data in sheet.iter_rows():
    for cell in one_column_data:
        print(cell.value)
